package me.zhengjie.modules.bushutongji.repository;

import me.zhengjie.modules.bushutongji.domain.Goods;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
* @author xiexidong 
* @date 2019-08-01
*/
public interface GoodsRepository extends JpaRepository<Goods, Integer>, JpaSpecificationExecutor {
    @Query(value = "select * from goods where bushutongjiid = ?1",nativeQuery = true)
    List<Goods> findGoodsById(int id);

}